--Execute as sys
CREATE TABLESPACE sf_tbs1
 DATAFILE 'sf_tbs1.dbf' SIZE 1500M REUSE
 AUTOEXTEND ON NEXT 200M
 MAXSIZE 3000M
 SEGMENT SPACE MANAGEMENT AUTO;

CONNECT oe/oe
CREATE TABLE customer_profiles_sf
(id NUMBER,
 first_name VARCHAR2 (40),
 last_name  VARCHAR2 (80),
 profile_info  BLOB)
 LOB(profile_info) STORE AS SECUREFILE
 (TABLESPACE sf_tbs1);
